clear all
set more off
set matsize 10000
tempfile ubigeo temp


local lista trust_police trust_army trust_church trust_newsp trust_rtv trust_parties trust_regi trust_jury trust_parliament trust_jne trust_onpe
local controls schooling male rural native married head 

use mergedp, clear
egen voted_bn = rowmax(voted_blank voted_null)
recode voted_blank voted_null voted_bn (. = 0) if voted == 0

** LABELS
label var todoAT "Violence Exposure"

******* Results
drop if vote_matter == .
local lista vote_matter voted voted_blank voted_bn voted_null partN dem_works dem_matters1 gov_demo1 gov_auto1

local r = 1
foreach var in `lista' {
	replace `var' = `var' * 100 if `r' != 6
	reghdfe `var' todoAT `controls', abs(i.age i.year) vce(cluster ubigeonac1993) keepsin
	est store reg`r'
	sum `var' if e(sample) == 1
	local y = r(mean)
	sum todoAT if e(sample) == 1 & todoAT
	local sd = r(mean)
	local n`r' = (round(((_b[todoAT]) * `sd') / `y', 0.0001)) * 100
	local ++r
}

noisily estout reg* ///
using Table_4_0.tex, style(tex) c(b(fmt(3) star) se(par fmt(3))) ///
	label collabels(, none) eqlabels(none) mlabels(, none) varlabel(_cons " $ Control $ ") starlevel(* .1 ** .05 *** .01) ///
	keep(todoAT) ///
	order(todoAT) ///
	stats(r2 N N_clust, fmt(%9.2f %9.0g) labels(`"$ R ^{2}$"' "Observations" "Clusters")) replace 

texdoc init Table_4.tex, replace
tex \begin{table}[h]
tex \caption{Impact of armed conflict on voting, participation and democratic beliefs}
tex \label{tab:Table_4}
tex \begin{center}
tex \resizebox{16cm}{!}{
tex \begin{tabular}{lcccccccccc} \hline \hline
tex \\
tex & Voting & \multicolumn{4}{c}{Voted in last elections}& Participation & \multicolumn{2}{c}{Democracy} & \multicolumn{2}{c}{Type of preferred gov.} \\
tex & matters & Yes & ...blank & ...null & ...blank & organisations & works & matters & Democracy & Autocracy \\
tex &  & &&& or null & &&&& \\
tex & (1) & (2) & (3) & (4) & (5) & (6) & (7) & (8) & (9) & (10) \\
tex \hline
tex \input{Table_4_0.tex}
tex &&&&&&&&&& \\
tex \multicolumn{8}{l}{\textbf{Effect of 1 s.d. change in conflict measure as \% of mean of dependent variable:}} \\
tex & `n1' & `n2' & `n3' & `n4' & `n5' & `n6' & `n7' & `n8' & `n9' & `n10' \\
tex &&&&&&&&&& \\
tex \hline
tex \end{tabular}}
tex \end{center}
tex \end{table}
